Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 383
	Members: 0
	Total: 383

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Best Way to add spaces in Header of a CSV file via batch Program

6 Replies

1 Subscribed to this topic

18 Subscribed to this forum

Sort:

Author

Messages

Vijay S

Veteran Member

Posts: 174

New Poster

11/13/2015 7:32 AM

Dear All,

What is the best way to add spaces in a Header for a CSV file which is generated via a Lawson 4GL batch program while using 800-WRITECSV-. I also need to add a field "Debit/Credit Separator" in the file with spaces and "/". what is the best and simple way to achieve this. CSV files doesn't take spaces and "/" when defining it in workdef.

Thanks

Vijay

Ragu Raghavan

Veteran Member

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

11/13/2015 10:57 AM

One way of doing this:
1. define file in workdef not to have column headings
2. create the file without headings
3. define the column headings in WS
4. create a file with just the column headings
5. 'cat' the two files- you now have a csv file with the desired headings

jaherb

Veteran Member

Posts: 164

New Poster

11/13/2015 2:55 PM

I accomplish this using a similar method described by Ragu. In my case, I create a text file and store it on the server, the way that I need it to be. I set the csv file up to not print headers and then at the close of the program, I concatenate the header file with the data file. Works great!

Woozy

Veteran Member

Posts: 709

New Poster

11/13/2015 4:22 PM

I believe you can also do this within the COBOL code using 800-OVRDESCCSV. See the "Doc for Developers: Lawson 4GL Application Program Interfaces" document for details about this call.

jaherb

Veteran Member

Posts: 164

New Poster

11/13/2015 8:03 PM

Interesting, Kelly... have never used that routine.

Woozy

Veteran Member

Posts: 709

New Poster

11/13/2015 10:29 PM

Here are a couple of screenshots to show how this works:

Vijay S

Veteran Member

Posts: 174

New Poster

11/17/2015 10:07 AM

Thanks ! I was able to achieve this.