Hi Guys,
Good Morning to you all. I need some help to reformat and replace some text within strings of texts.
Please find the script below:
DECLARE @splitstringTest TABLE (
filelink varchar(255),
Secondfilelink varchar(255)
);
INSERT INTO @splitstringTest ( filelink,Secondfilelink )
VALUES ('Q:\ARR.CSV','M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\TEN001.DOCX /mQLEDM'),
('C:\QLTEMP\CRM.CSV','M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\WLRTB.DOCX /MQLEDM'),
('C:\QLTEMP\TENDER.CSV','M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\SO0001.DOCX /mQLEDM')
Select * from @splitstringTest
Output Result:
filelink Secondfilelink
Q:\ARR.CSV M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\TEN001.DOCX /mQLEDM
C:\QLTEMP\CRM.CSV M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\WLRTB.DOCX /MQLEDM
C:\QLTEMP\TENDER.CSV M:\QL_LETTERS\DOCCTRL.BAT M:\QL_LETTERS\MASTERS\SO0001.DOCX /mQLEDM
Desired Output: I need to replace the filelink with the Newfilelink below
Newfilelink: Q:\ARR.CSV
Desired output2: I need to replace the secondfilelink with the Newsecondfilelink
NewSecondfilelink: \ah-qlapp-01\QLStore\QL_Letters\DOCCTRL.BAT \ah-qlapp-01\QLStore\QL_Letters\MASTERS\ARR070.DOCX /mQLEDM
Thanks
Bobby