issue with csv file name with special character infile statement

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

issue with csv file name with special character infile statement

i am importing multiple csv files from a folder using infile statement. Some files give me error Physical file not found. When i rename it , it works file.

 

Example of file name with issue- ab[bmp]c[8_4_203].csv

when i remove square [] brackets it works fine.

 

Is there a way i can take care of all special characters when reading csv file using infile statement?

 


Accepted Solutions
Solution
3 weeks ago
Esteemed Advisor
Posts: 6,650

Re: issue with csv file name with special character infile statement

A UNIX system interprets angular brackets as part of regular expressions for filename expansion. Having them in UNIX filenames is a VERY BAD idea. Just like having asterisks and question marks

 

Strong hint: use only characters from the 26-character alphabet, digits, underlines and dots in filenames. Makes life on all operating systems so much simpler.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
3 weeks ago
Esteemed Advisor
Posts: 6,650

Re: issue with csv file name with special character infile statement

A UNIX system interprets angular brackets as part of regular expressions for filename expansion. Having them in UNIX filenames is a VERY BAD idea. Just like having asterisks and question marks

 

Strong hint: use only characters from the 26-character alphabet, digits, underlines and dots in filenames. Makes life on all operating systems so much simpler.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 83 views
  • 0 likes
  • 2 in conversation