RE: Split column with dynamic data

2017-10-30 Thread Aakash Basu
* Aakash Basu [mailto:aakash.spark@gmail.com] > *Sent:* 30 October 2017 18:53 > *To:* user > *Subject:* Split column with dynamic data > > > > External email: use caution > > > > Hi all, > > > > I've a requirement to split a column and

RE: Split column with dynamic data

2017-10-30 Thread Hondros, Constantine (ELS-AMS)
($”Description”, “^\d+A-Z?\.”, “”)) From: Aakash Basu [mailto:aakash.spark@gmail.com] Sent: 30 October 2017 18:53 To: user Subject: Split column with dynamic data *** External email: use caution *** Hi all, I've a requirement to split a column and fetch only the description where I

Split column with dynamic data

2017-10-30 Thread Aakash Basu
Hi all, I've a requirement to split a column and fetch only the description where I have numbers appended before that for some rows whereas other rows have only the description - Eg - (Description is the column header) *Description* Inventory Tree Products 1. AT&T Services 2. Accessories 4. Misc