Search Results

Hi Friends,
We have a situation where we need to pass API based URL which will return XML response ,and I need to convert those XML response to a delimited flat file.

url.txt -- will have...

Hi,
I need to implement below logic to download files daily from a URL.

* Need to check if it is yesterday's file (YYYY-DD-MM.dat)
* If present then download from URL...

Hi Guru's,
I have a requirement where i need to convert rows to column based on a key column.

Input:
Account_id|Trip_Org|Trip_Dest|City|Hotel_Nm
123|DFW|CHI|Dallas|Hyatt...

I have below scenario where i am getting a flat file but with some bad data

incoming data format
id|name|ind|crncy
123|xxx|y|usd
234|yy|n|
456|a|y90.5|vvv|gbp ----bad dataneed to cleanse the...

Thanks bipinajith ,your code solved my requirement.

zcat ${file} | awk -v fname=${file} '{print fname "|" $0}'

I want to append file names at the beginning of a line for each row

file content
abc.txt.gz 123|654|987
bcd.txt.gz 876|trf|kjh

I want a single output file with below format...