Page 1 of 1
Posted: Tue Nov 07, 2006 9:06 am
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.
Posted: Tue Nov 07, 2006 9:57 am
by chulett
Actually, just type the '253'... no alt required.
Posted: Tue Nov 07, 2006 1:41 pm
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.
Posted: Wed Nov 08, 2006 8:48 am
by tagnihotri
Have tried on a test job working fine for me !
Posted: Wed Nov 08, 2006 10:58 am
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
Posted: Wed Nov 08, 2006 9:05 pm
by coolbin81
Thanks a lot guys for your help!
Posted: Mon Sep 02, 2019 8:28 am
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];
...
Posted: Tue Sep 03, 2019 7:08 am
by chulett
Wow... this might be a record.
Posted: Wed Sep 04, 2019 5:38 am
by qt_ky
I thought the same thing!