* 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
($”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
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