Use of special characters as delimiter in sequential file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am

Post by Krazykoolrohit »

in the delimiter space, type as following.

press 'ALT' and type 253
release alt.

this is the way you type ASCII characters. run the job after this.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm

Post by chulett »

Actually, just type the '253'... no alt required. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am

Post by narasimha »

coolbin81 wrote:These solutions don't work!

What errors do you get?


Give an example of how your flat file looks.
coolbin81 wrote:And using normal delimiter option will allow us to enter only a single character.

This is true.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
tagnihotri
Participant
Posts: 83
Joined: Sat Oct 28, 2006 6:25 am

Post by tagnihotri »

Have tried on a test job working fine for me !
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am

Post by narasimha »

Like Craig said you dont need to press ALT, you can just enter 253

But if you want to go the "ALT" way then use ASCII 0253
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
coolbin81
Participant
Posts: 6
Joined: Wed Oct 04, 2006 2:50 pm

Post by coolbin81 »

Thanks a lot guys for your help!
bkerebel
Participant
Posts: 15
Joined: Wed Jan 05, 2005 3:18 am

Post by bkerebel »

Hi all,
for information if you have trouble to use a special delimiter or quote character to read a Sequential file, you can use a schema file and the import column

Exemple : if you use double quote for the quote, you can use ASCII value

record
{final_delim=end, delim='|', quote="\0"}
(
INV_ID:string[max=20];
VEH_ID_NBR:string[max=17];
...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm

Post by chulett »

Wow... this might be a record. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am

Post by qt_ky »

I thought the same thing! :lol:
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply