DB2 V8 String Parsing Question

2 New Member

Dear DB2 Experts,
I have many rows in a table which is of the format as shown below. The last column starting from "#Wed Oct 08 13:51:35 EDT 2008 to the closing " after the ROUNUM are multi-lines.

2250307,"120005",1,2493133200000,1,0,"#Wed Oct 08 13:51:35 EDT 2008
C_NUMBER=5001
RNUMBER=1234567890
CH_AMOUNT=50.00
RO_NUM=011401533
AC_NUMBER=223344557788
AlType=ItemCleared
ACCNUMBER=223344557788-1
ACC_TYPE=Checking
ONETIME=true
ROUNUM=012345660
"
I would like to know if there is way to combine all the multilines into a single line separated by a separator like
2250307,"120005",1,2493133200000,1,0,"#Wed Oct 08 13:51:35 EDT 2008,
C_NUMBER=5001,RNUMBER=1234567890,CH_AMOUNT=50.00,R O_NUM=011401533,AC_NUMBER=223344557788,AlType=Item Cleared,ACCNUMBER=223344557788-1,ACC_TYPE=Checking,ONETIME=true,ROUNUM=012345660"

Thank you in advance for your reply.
Kumar

Oct 12 '08 #1

Subscribe Reply

2982

docdiesel

297

Recognized Expert Contributor

Hi,

you may use the REPLACE() function of DB2 (see also IBM DB2 Infocenter). I guess you'll have to escape the LF character as CHAR(10), or if it's text from a Windows system CHAR(10*256+13).

Regards

Doc Diesel

Oct 13 '08 #2

Similar topics

3896

String Parsing question. (winamp.pls)

by: Michael Hogan | last post by:

I want to pars a playlist file for three different varibles, so I can save them as mp3 files. I am using: strTEMPURL = GetUrlSource(Text1.Text) to put the entire .pls file into a strTEMPURL...

Visual Basic 4 / 5 / 6

3598

Parsing a search string

by: Freddie | last post by:

Happy new year! Since I have run out of alcohol, I'll ask a question that I haven't really worked out an answer for yet. Is there an elegant way to turn something like: > moo cow "farmer john"...

Python

808

splitting a string and put it into an array

by: Kai Jaensch | last post by:

Hello, i am an newbie and i have to to solve this problem as fast as i can. But at this time i don´t have a lot of success. Can anybody help me (and understand my english :-))? I have a...

C / C++

2611

String tokens/parsing

by: Christopher Benson-Manica | last post by:

(if this is a FAQ, I apologize for not finding it) I have a C-style string that I'd like to cleanly separate into tokens (based on the '.' character) and then convert those tokens to unsigned...

C / C++

8388

String Parsing

by: Bob Davis | last post by:

In C# one can construct a string using the format method. for example string newstring = string.Format("CC%d-%s.%d-%s-% d",123,"aaaa",456,"bbb",789); The resulting newstring will be...

C# / C Sharp

4225

Parsing a Section of Binary String Data!

by: zoltan | last post by:

Hi, The scenario is like this : struct ns_rr { const u_char* rdata; }; The rdata field contains some fields such as :

C / C++

1375

string parsing question

by: igotyourdotnet | last post by:

I have a question. I'm reading a CSV file that is uploading to my SQL db, I'm parsing out the file line by line. I'm getting the values and putting them into an arrayList seperate by commas. The...

ASP.NET

2060

String parsing

by: dimasteg | last post by:

Hi all C. Nead some help with string "on the fly" parsing, how it can be realized ? Any ideas? I got some of my own, but it's interesting to get other points of view . Regards.

C / C++

1401

RE: parsing "&A" in a string..

by: bruce | last post by:

Hi Fredrick Thanks for the reply. But since I don't have control of the initial text, is there something with python that will strip/replace this... or are you saying I should do a...

Python

4351

String converting to Stack/ Parsing

by: eyeore | last post by:

Hello everyone my String reverse code works but my professor wants me to use pop top push or Stack code and parsing code could you please teach me how to make this code work with pop top push or...

Java

7133

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7405

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7066

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5059

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4724

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3214

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3198

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

773

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

435

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General