topic Removing header from a Document variable in Talend job in Talend Studio

Removing header from a Document variable in Talend job

Anonymous — Wed, 05 Jul 2017 06:48:21 GMT

I have an XML stored in a Document type variable in Talend job.

<?xml version="1.0" encoding="UTF-8"?>
<ORDER><HEAD><DOC_STATUS>...</DOC_STATUS></HEAD></ORDER>

I convert it with the tConvertType to String but I have header that I dont need left:
<?xml version="1.0" encoding="UTF-8"?>

What is the best way to remove this above in Talend?

Re: Removing header from a Document variable in Talend job

TRF — Wed, 05 Jul 2017 07:46:46 GMT

Try yourString.replaceAll("^<\?xml.*\?>", "")

Re: Removing header from a Document variable in Talend job

idembel2 — Tue, 24 Apr 2018 09:33:40 GMT

Hi TRF,
I try your suggestion, but i got a bug.
Bellow, code works for me:

yourString.replaceAll("\\<\\?xml(.+?)\\?\\>", "")

Ibrahim