issue with csv file name with special character infile statement

Accepted Solution Solved
Reply
Contributor
Posts: 29
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
‎07-05-2017 01:37 PM
Super User
Posts: 7,422

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
‎07-05-2017 01:37 PM
Super User
Posts: 7,422

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
  • 128 views
  • 0 likes
  • 2 in conversation