cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar

Is it possible to add two repression for END of Field? I need to add *F* or ' for field separation.

ConfidenceOwl94_0-1739542228124.png

 

3 REPLIES 3
jthi
Super User

Re: Is it possible to add two repression for END of Field? I need to add *F* or ' for field separation.

Not sure what can be done in UI/Multiple File Import, but https://www.jmp.com/support/help/en/18.1/#page/jmp/file-functions.shtml?os=win&source=application#ww...

End Of Field("Tab"|"Space"|"Comma"|"Semicolon"|"Other"|"None")

Specifies the quoted character used to delimit the end of a field in the imported text file. To specify multiple characters, separate each character designation by a comma. If you use "Other", designate the delimiter with EOF Other() argument.

-Jarmo

Re: Is it possible to add two repression for END of Field? I need to add *F* or ' for field separation.

Hi Jarmo,

 

Can you tell me what have I done wrong here?

ConfidenceOwl94_0-1739544781870.png

 

 

jthi
Super User

Re: Is it possible to add two repression for END of Field? I need to add *F* or ' for field separation.

What I did paste might be related that if you have multiple "pre-determined" separators.

 

Usually, if JMP's Open() isn't able to handle my text files, I just immediately go with scripting route and write my own custom parser.

 

Edit: I think the part I should have looked at was combination of End Of Field and

EOF Other(char)

If the imported text file uses an end-of-field character other than the one specified by End of Field(), this argument specifies the character used.

-Jarmo

Recommended Articles