cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • We’re improving the Learn JMP page, and want your feedback! Take the survey
  • JMP monthly Newswire gives user tips and learning events. Subscribe
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