topic Re: how to split a complex string in Application Development and Automation Discussions

how to split a complex string

manish_malakar0316 — Thu, 04 May 2023 06:52:50 GMT

Hi Experts,

I have a string which is separated by comma. However, I cannot use the SPLIT statement as the comma is used in denoting amounts as well, for e.g. "123,456,000" and also they are enclosed within quotes (please refer to the attachment). So when there are no values, they are filled with zero and separated by commas. But when there are values, it becomes complex to separate them and store them in an internal table in their respective columns. Any idea how it can be done ?

My internal table is declared as follows and I have to strore them inside the fields declared.

Regards,

Manish

BEGIN OF ty_interest_calc,<br>          date(10),<br>          fund_name(50),<br>          cusip_isin(15),<br>          acnt_no(10),<br>          div_rate(13),<br>          ded_rate(13),<br>          daily_div(13),<br>          mtd_div(10),<br>          position_local(12),<br>          fx_rate(1),<br>          position_usd(12),<br>          nav(1),<br>          shares(12),<br>          acnt_name(50),<br>          curr(3),<br>          company_name(20),<br>          tax_id(10),<br>        END OF ty_interest_calc.<br>

Re: how to split a complex string

Tomas_Buryanek — Thu, 04 May 2023 07:12:06 GMT

This looks like normal CSV format.

Try cl_rsda_csv_converter to read data from the string to your structure. There are many examples how to use this class 🙂

Re: how to split a complex string

Sandra_Rossi — Thu, 04 May 2023 07:28:44 GMT

Be careful to <br> tags in the code you posted. You may fix it via Actions > Edit. This is correct formatting:

TYPES : BEGIN OF ty_interest_calc,
          date(10),
          fund_name(50),
          cusip_isin(15),
          acnt_no(10),
          div_rate(13),
          ded_rate(13),
          daily_div(13),
          mtd_div(10),
          position_local(12),
          fx_rate(1),
          position_usd(12),
          nav(1),
          shares(12),
          acnt_name(50),
          curr(3),
          company_name(20),
          tax_id(10),
        END OF ty_interest_calc.

Re: how to split a complex string

Sandra_Rossi — Thu, 04 May 2023 07:29:28 GMT

Also, you can show the image directly in your question (with just copy/paste)

Re: how to split a complex string

BaerbelWinkler — Thu, 04 May 2023 07:33:46 GMT

manish.malakar0316

Hi Manish!

Do you have control over the string format and/or can request a change from "," to something rarely used in field content like e.g. "|"? This would be a lot easier than trying to wrestle with the variable nature of where a comma can show up.

A comma or even semi-colon are rarely a good option to use as a field delimiter because they tend to show up in user entered content or numbers as in your case.

Cheers

Bärbel

Re: how to split a complex string

BaerbelWinkler — Thu, 04 May 2023 07:34:45 GMT

tomas.buryanek

Thanks for the tip with the class, Tomas! It might come in handy in the future!

Cheers

Bärbel

Re: how to split a complex string

Tomas_Buryanek — Thu, 04 May 2023 08:53:09 GMT

8b889d0e8e6f4ed39f6c58e35664518f You are welcome 🙂

By the way, I used this class quite many times already, and it was always helpful and without a problem.

Re: how to split a complex string

manish_malakar0316 — Thu, 04 May 2023 09:21:13 GMT

Thanks Tomas...this was the correct solution !