sana sheikh
New Member
Members
Forum Posts: 2
Member Since:
November 6, 2021
November 6, 2021
Offline
Hi,
I am trying to extract values in a coulum which has values start with a number. This column has values starting with a number and starting with a alphabatic letter both without any pattern. Therefore, I can't use modulo.
I have been using a query to extract the vlaues strating with specific number and it works (for example ( if Text.StartsWith([Our Ref_1],"5") then [Our Ref_1] else null)))
But now my range is 0-9, it could be any number I want to extract whole value starting with number and I am struggling with the range.
For example, as in the picture I want to keep/extract whole value starting with '10100, computer equipment - brought forward'
Sana
Alan Sidman
Steamboat Springs, CO
Member
Members
Trusted Members
Trusted Members
Forum Posts: 193
Member Since:
October 18, 2018
October 18, 2018
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Kathleen Silva, Arta S
Guest(s) 8
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —